---
title: "Open Source Database Repos Landscape 2021"
try_it_yourself:
  campaign: insight_database
---

import {CommonChart} from "../src/components/CommonChart";

In this chapter, we will share with you some of **the top Open Source Database repos (OSDB repos) on GitHub in 2021** measured by different metrics including the number of stars, PRs, contributors, countries, regions and so on. 

Note: 
1. You can move your cursor onto any of the repository bars/lines on the chart and get the exact number. 
2. The SQL commands above each chart are what we use on our TiDB Cloud to get the analytical results. Try those SQL commands by yourselves on TiDB Cloud with this [10-minute tutorial](/blog/try-it-yourself/).

## Star history of top OSDB repos since 2011

The number of stars is often thought of as a measure of whether a github repository is popular or not. We sort all database repositories from github by the total number of historical stars since 2011. For visualizing the results more intuitively, we show the top 10 open source databases by using an interactive line chart. 

<CommonChart
    chart='dynamic-stars'
    category='archive/2021/repo-racing-by-stars'
    formatSql={false}
    categoryIndex='repo_name'
    valueIndex='cumulative_stars'
    field='database'
/>

## Top 10 the most starred OSDB repos in 2021

<CommonChart
    chart='yoychart'
    category='archive/2021/repo-ranking-by-yoy-stars-growth'
    formatSql={false}
    categoryIndex='repo_name'
    valueIndex='stars'
    seriesName='Stars'
    field='database'
/>

## Top 10 OSDB repos with the most PRs in 2021

<CommonChart
    chart='barchart'
    category='archive/2021/repo-ranking-by-prs'
    formatSql={false}
    categoryIndex='repo_name'
    valueIndex='prs'
    seriesName='PRs'
    field='database'
    n={10}
/>

## Top 20 contributors in OSDB repos

<CommonChart
    chart='barchart'
    category='archive/2021/repo-pr-creator-ranking-by-prs'
    formatSql={false}
    categoryIndex='actor_login'
    valueIndex='prs'
    categoryType='owner'
    seriesName='PRs'
    field='database'
    n={10}
/>

## Top 20 OSDB repos with the highest YoY growth rate of stars in 2021

<CommonChart
    chart='yoychart'
    category='archive/2021/repo-ranking-by-yoy-stars-growth'
    formatSql={false}
    field='database'
/>


## Top 10 OSDB repos with the lowest YoY growth rate of stars in 2021

<CommonChart
    chart='yoychart'
    category='archive/2021/repo-ranking-by-yoy-stars-growth-least'
    formatSql={false}
    field='database'
/>

## Top 5 programming languages used in OSDB repos in 2021

<CommonChart
    chart='barchart'
    category='archive/2021/language-ranking-by-prs'
    formatSql={false}
    categoryIndex='language'
    valueIndex='prs'
    categoryType='lang'
    seriesName='PRs'
    field='database'
/>

## Top 20 companies contributing the most to OSDB repos in 2021

<CommonChart
    chart='barchart'
    category='archive/2021/company-ranking-by-contributions'
    formatSql={false}
    categoryIndex='company'
    valueIndex='contributions'
    seriesName='Contributions'
    categoryType={false}
    field='database'
/>

## Top 10 countries/regions contributing the most to OSDB repos in 2021

<CommonChart
    chart='worldmapchart'
    category='archive/2021/country-ranking-by-contributions'
    formatSql={false}
    categoryIndex='country_code'
    seriesName='Contributions'
    valueIndex='contributions'
    field='database'
/>

## The Rankings of OSDB repos on GitHub measured by Z-score in 2021

The previous analysis results were only evaluated from a single dimension, now let's evaluate them from a multidimensional perspective. We can try to rank the repositories based on the [Z-score](https://en.wikipedia.org/wiki/Standard_score) standard.

This is the comprehensive ranking calculated by z-score:

<CommonChart
    chart='zscorechart'
    category='archive/2021/repo-ranking-by-z-score'
    formatSql={false}
    field='database'
    n={50}
/>